• About
  • Key terms
  • Interface overview
    • Screen elements
    • Toolbar
    • Education pane
    • Quick actions box
    • Keyboard shortcuts
    • Language
  • Files
    • New file
    • Save as template
    • New from template
    • Open a file
    • Convert a file
    • Recent files
    • Open with
    • Send a file
    • Print document without entering the application
    • Preview and print
    • Save a file
    • Export to
    • Autorecovery of documents
    • Close a file
  • Sheets
    • Insert a sheet
    • Rename a sheet
    • Hide or unhide sheets
    • Duplicate a sheet
    • Change sheets order
    • Zoom a sheet
    • Hide or display zero values
    • Delete a sheet
  • Cells, columns, and rows
    • Expand the workspace
    • Select cell ranges
    • Resize cells
    • Merge or unmerge cells
    • Insert columns or rows
    • Select colums or rows
    • Hide or unhide a column or row
    • Resize a column or row
    • Freeze columns, rows, or area
    • Group columns or rows
    • Delete columns or rows
  • Data
    • Enter data
    • Sort and filter
    • Number formats
    • Data validation
    • Remove duplicates
    • Links
    • Notes
    • Special characters
    • Current date or time
    • Check spelling
    • Find and replace
    • Delete data
  • Formulas and functions
    • Formulas and functions basics
    • Order of operations in a formula
    • Reference cells and cell ranges
    • Recalculation of formulas
    • Automatic calculation
    • Insert functions
    • Replace a formula with its result
    • Copy and insert formulas
    • Names in formulas and functions
    • Reference to data in another document
    • Structured references
  • Calculation operators
    • Arithmetic operators
    • Comparison operators
    • Text concatenation operator 
    • Reference operators
  • Pivot tables
    • Create a pivot table
    • Open the pivot table settings pane
    • Customize a pivot table
    • Customize the pivot table parameters
    • Collapse or expand the elements of pivot table
    • Refresh a pivot table
    • Delete a pivot table
  • Charts
    • Create a chart
    • Chart settings
    • Move a chart
    • Copy, cut or insert a chart
    • Change chart type
    • Resize a chart
    • Change data in chart
    • Change chart data source
    • Delete a chart
  • Images
    • Insert an image
    • Resize an image
    • Move an image
    • Save an image
    • Delete an image
  • Shapes
    • Insert a shape
    • Fill a shape
    • Outline
    • Line style
    • Resize a shape
    • Fit shape size to text
    • Change line length and angle
    • Select arrow type
    • Move a shape
    • Delete a shape
  • Format
    • Font
    • Font size
    • Font formatting
    • Font сolor
    • Highlight color
    • Alignment
    • Rotate text
    • Wrap text
    • Character spacing
    • Cell background color
    • Cell borders
    • Copy and apply formatting
  • Edit content
    • Undo and redo
    • Clipboard
  • Cloud actions
    • Log in
    • Open a file
    • Create a local copy
    • Create a file or folder
    • Upload a file
    • Download a file or folder
    • Delete a file
    • Restore a file or folder
    • Shared access to files
    • Collaboration
    • Revoke own access
    • Log out
  • Automation tools
    • Macros
    • Extensions
  • Document protection
    • Protect document with a password
    • Protect content from changes
  • Appendices
    • Appendix A. List of functions
    • Appendix B. List of supported currencies